SELECT *, CASE WHEN `name` LIKE "nags head%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "nags head" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "nags head" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "nags head" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "NC" AND (locality IN ("nags head") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 10
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NC" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 10
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$3,300,0006323 Virginia Dare Trl SNags Head NC 27959View Listing
$2,900,0009023 Gerhard St ENags Head NC 27959View Listing
$2,439,0002703 S Virginia Dare TrlNags Head NC 27959View Listing
$2,300,0009421 S Old Oregon Inlet RdNags Head NC 27959View Listing
$1,795,0003709 Virginia Dare Trl SNags Head NC 27959View Listing
$1,649,0005306 Virginia Dare Trl SNags Head NC 27959View Listing
$1,395,0005002 Virginia Dare Trl SNags Head NC 27959View Listing
$1,350,000300 Driftwood St ENags Head NC 27959View Listing
$1,349,0008435 Old Oregon Inlet Rd SNags Head NC 27959View Listing
$1,250,0005332 Captains WayNags Head NC 27959View Listing
$1,230,0007217 S Croatan HwyNags Head NC 27959View Listing
$1,200,000108 Lone Cedar CtNags Head NC 27959View Listing
$1,100,0003533 Memorial Ave SNags Head NC 27959View Listing
$995,0008713 Old Oregon Inlet Rd SNags Head NC 27959View Listing
$980,0002612 S Memorial AveNags Head NC 27959View Listing
$950,0009701C Nansemond St ENags Head NC 27959View Listing
$949,9003504 Linda Ln SNags Head NC 27959View Listing
$939,0007724 Virginia Dare Trl SNags Head NC 27959View Listing
$934,5006103 Mid Shore Ct SNags Head NC 27959View Listing
$899,0002707 Memorial Ave SNags Head NC 27959View Listing
$899,000117 Oregon Dr ENags Head NC 27959View Listing
$899,0004704 Virginia Dare Trl SNags Head NC 27959View Listing
$895,0004812 Engagement Hill Loop ENags Head NC 27959View Listing
$875,0005313 Sand Wedge Ln SNags Head NC 27959View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-09-2024 9:41:18 am.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NC" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 10
Blah
Ranch
Single Family
